﻿CREATE TABLE [dbo].[PlantAudit] (
    [PlantAuditID]        UNIQUEIDENTIFIER NOT NULL,
    [PlantID]             BIGINT           NOT NULL,
    [PlantAuditTypeID]    INT              NOT NULL,
    [PlantAuditDate]      DATETIME         NOT NULL,
    [PlantLoggedInUserID] INT              NOT NULL,
    [PlantStateID]        INT              NOT NULL,
    [PlantConditionID]    INT              NOT NULL,
    [PlantAuditNote]      NVARCHAR (2000)  NULL
);

